Calculate averages across two ranges while excluding blank and zero values using SUMPRODUCT instead of AVERAGEIF.